Overview

Brought to you by YData

Dataset statistics

Number of variables	25
Number of observations	10000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.9 MiB
Average record size in memory	200.0 B

Variable types

Text	3
DateTime	4
Numeric	6
Categorical	11
Boolean	1

Alerts

`loan_amount_allowed` is highly overall correlated with `sum_assured_inr/coverage_amount`	High correlation
`payment_frequency` is highly overall correlated with `payment_frequency_days`	High correlation
`payment_frequency_days` is highly overall correlated with `payment_frequency`	High correlation
`policy_code` is highly overall correlated with `policy_type_code` and 1 other fields	High correlation
`policy_type_code` is highly overall correlated with `policy_code` and 1 other fields	High correlation
`purchase_month` is highly overall correlated with `purchase_quarter`	High correlation
`purchase_quarter` is highly overall correlated with `purchase_month`	High correlation
`rm_id` is highly overall correlated with `sales_agent_code` and 2 other fields	High correlation
`sales_agent_code` is highly overall correlated with `rm_id` and 2 other fields	High correlation
`state` is highly overall correlated with `rm_id` and 2 other fields	High correlation
`sum_assured_inr/coverage_amount` is highly overall correlated with `loan_amount_allowed`	High correlation
`tenure_(years)` is highly overall correlated with `policy_code` and 1 other fields	High correlation
`zonal_manager_id` is highly overall correlated with `rm_id` and 2 other fields	High correlation
`policy_status` is highly imbalanced (53.5%)	Imbalance
`sum_assured_inr/coverage_amount` has unique values	Unique

Reproduction

Analysis started	2025-11-11 14:19:42.341636
Analysis finished	2025-11-11 14:19:58.878970
Duration	16.54 seconds
Software version	ydata-profiling vv4.17.0
Download configuration	config.json

policy_number
Text

Distinct	9938
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Length

Max length	14
Median length	14
Mean length	14
Min length	14

Characters and Unicode

Total characters	140000
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9876 ?
Unique (%)	98.8%

Sample

1st row	TRS-POL-287638
2nd row	TRS-POL-983850
3rd row	TRS-POL-892387
4th row	TRS-POL-204292
5th row	TRS-POL-621019

Value	Count	Frequency (%)
trs-pol-266400	2	< 0.1%
trs-pol-114616	2	< 0.1%
trs-pol-762117	2	< 0.1%
trs-pol-833719	2	< 0.1%
trs-pol-314657	2	< 0.1%
trs-pol-347852	2	< 0.1%
trs-pol-299262	2	< 0.1%
trs-pol-248874	2	< 0.1%
trs-pol-147304	2	< 0.1%
trs-pol-192272	2	< 0.1%
Other values (9928)	9980	99.8%

Most occurring characters

Value	Count	Frequency (%)
-	20000	14.3%
T	10000	7.1%
R	10000	7.1%
S	10000	7.1%
P	10000	7.1%
O	10000	7.1%
L	10000	7.1%
6	6234	4.5%
2	6171	4.4%
7	6131	4.4%
Other values (7)	41464	29.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	140000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	20000	14.3%
T	10000	7.1%
R	10000	7.1%
S	10000	7.1%
P	10000	7.1%
O	10000	7.1%
L	10000	7.1%
6	6234	4.5%
2	6171	4.4%
7	6131	4.4%
Other values (7)	41464	29.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	140000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	20000	14.3%
T	10000	7.1%
R	10000	7.1%
S	10000	7.1%
P	10000	7.1%
O	10000	7.1%
L	10000	7.1%
6	6234	4.5%
2	6171	4.4%
7	6131	4.4%
Other values (7)	41464	29.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	140000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	20000	14.3%
T	10000	7.1%
R	10000	7.1%
S	10000	7.1%
P	10000	7.1%
O	10000	7.1%
L	10000	7.1%
6	6234	4.5%
2	6171	4.4%
7	6131	4.4%
Other values (7)	41464	29.6%

start_date
Date

Distinct	3237
Distinct (%)	32.4%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Minimum	2015-01-08 00:00:00
Maximum	2024-12-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

last_paid_date
Date

Distinct	1841
Distinct (%)	18.4%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Minimum	2016-03-28 00:00:00
Maximum	2025-12-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

tenure_(years)
Real number (ℝ)

High correlation

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.1789

Minimum	10
Maximum	25
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	10
5-th percentile	10
Q1	12
median	20
Q3	20
95-th percentile	25
Maximum	25
Range	15
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	5.4460867
Coefficient of variation (CV)	0.29958285
Kurtosis	-1.2798103
Mean	18.1789
Median Absolute Deviation (MAD)	5
Skewness	-0.32459948
Sum	181789
Variance	29.659861
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
20	4177	41.8%
25	2358	23.6%
10	1818	18.2%
12	1235	12.3%
15	395	4.0%
22	17	0.2%

Value	Count	Frequency (%)
10	1818	18.2%
12	1235	12.3%
15	395	4.0%
20	4177	41.8%
22	17	0.2%
25	2358	23.6%

Value	Count	Frequency (%)
25	2358	23.6%
22	17	0.2%
20	4177	41.8%
15	395	4.0%
12	1235	12.3%
10	1818	18.2%

date_of_purchase
Date

Distinct	3430
Distinct (%)	34.3%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Minimum	2015-07-24 00:00:00
Maximum	2025-07-23 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

customer_id
Text

Distinct	9945
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	110000
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9890 ?
Unique (%)	98.9%

Sample

1st row	CUST-912138
2nd row	CUST-676760
3rd row	CUST-189349
4th row	CUST-567423
5th row	CUST-292627

Value	Count	Frequency (%)
cust-552109	2	< 0.1%
cust-290945	2	< 0.1%
cust-315473	2	< 0.1%
cust-970713	2	< 0.1%
cust-283690	2	< 0.1%
cust-398973	2	< 0.1%
cust-788106	2	< 0.1%
cust-141656	2	< 0.1%
cust-293235	2	< 0.1%
cust-710477	2	< 0.1%
Other values (9935)	9980	99.8%

Most occurring characters

Value	Count	Frequency (%)
C	10000	9.1%
U	10000	9.1%
S	10000	9.1%
T	10000	9.1%
-	10000	9.1%
4	6185	5.6%
2	6170	5.6%
5	6168	5.6%
9	6168	5.6%
6	6090	5.5%
Other values (5)	29219	26.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	110000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	10000	9.1%
U	10000	9.1%
S	10000	9.1%
T	10000	9.1%
-	10000	9.1%
4	6185	5.6%
2	6170	5.6%
5	6168	5.6%
9	6168	5.6%
6	6090	5.5%
Other values (5)	29219	26.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	110000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	10000	9.1%
U	10000	9.1%
S	10000	9.1%
T	10000	9.1%
-	10000	9.1%
4	6185	5.6%
2	6170	5.6%
5	6168	5.6%
9	6168	5.6%
6	6090	5.5%
Other values (5)	29219	26.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	110000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	10000	9.1%
U	10000	9.1%
S	10000	9.1%
T	10000	9.1%
-	10000	9.1%
4	6185	5.6%
2	6170	5.6%
5	6168	5.6%
9	6168	5.6%
6	6090	5.5%
Other values (5)	29219	26.6%

sum_assured_inr/coverage_amount
Real number (ℝ)

High correlation Unique

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1054222.3

Minimum	100316.82
Maximum	1999546.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	100316.82
5-th percentile	196491.26
Q1	577241.91
median	1059397.7
Q3	1527198.5
95-th percentile	1907294.4
Maximum	1999546.8
Range	1899229.9
Interquartile range (IQR)	949956.59

Descriptive statistics

Standard deviation	549260.89
Coefficient of variation (CV)	0.52101051
Kurtosis	-1.2055452
Mean	1054222.3
Median Absolute Deviation (MAD)	475548.59
Skewness	-0.0035187733
Sum	1.0542223 × 10¹⁰
Variance	3.0168752 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
684200.64	1	< 0.1%
1006981.05	1	< 0.1%
391180.06	1	< 0.1%
1153296.54	1	< 0.1%
1176121.67	1	< 0.1%
1572200.77	1	< 0.1%
1735695.76	1	< 0.1%
1185416.85	1	< 0.1%
995666.54	1	< 0.1%
662242.36	1	< 0.1%
Other values (9990)	9990	99.9%

Value	Count	Frequency (%)
100316.82	1	< 0.1%
100333.64	1	< 0.1%
100632.55	1	< 0.1%
100665.03	1	< 0.1%
100709.94	1	< 0.1%
100828.11	1	< 0.1%
101628.27	1	< 0.1%
101648.77	1	< 0.1%
102350.25	1	< 0.1%
102430.36	1	< 0.1%

Value	Count	Frequency (%)
1999546.76	1	< 0.1%
1999441.68	1	< 0.1%
1999264.17	1	< 0.1%
1998796.46	1	< 0.1%
1998525.18	1	< 0.1%
1998314.16	1	< 0.1%
1998311.26	1	< 0.1%
1998270.05	1	< 0.1%
1997605.61	1	< 0.1%
1997550.35	1	< 0.1%

premium_amount
Real number (ℝ)

Distinct	9995
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52261.483

Minimum	5028.98
Maximum	99997.01
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	5028.98
5-th percentile	9641.422
Q1	28251.645
median	52362.055
Q3	76051.84
95-th percentile	95333.279
Maximum	99997.01
Range	94968.03
Interquartile range (IQR)	47800.195

Descriptive statistics

Standard deviation	27511.888
Coefficient of variation (CV)	0.52642762
Kurtosis	-1.2063144
Mean	52261.483
Median Absolute Deviation (MAD)	23881.73
Skewness	0.011607776
Sum	5.2261483 × 10⁸
Variance	7.5690399 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
63835.33	2	< 0.1%
58252.59	2	< 0.1%
41203.82	2	< 0.1%
52662.24	2	< 0.1%
20252.27	2	< 0.1%
25882.43	1	< 0.1%
62045.93	1	< 0.1%
5973.76	1	< 0.1%
33635.08	1	< 0.1%
47823.59	1	< 0.1%
Other values (9985)	9985	99.9%

Value	Count	Frequency (%)
5028.98	1	< 0.1%
5055.75	1	< 0.1%
5060.84	1	< 0.1%
5066.79	1	< 0.1%
5082.21	1	< 0.1%
5089.12	1	< 0.1%
5093.81	1	< 0.1%
5096.33	1	< 0.1%
5096.9	1	< 0.1%
5109.71	1	< 0.1%

Value	Count	Frequency (%)
99997.01	1	< 0.1%
99976.71	1	< 0.1%
99974.54	1	< 0.1%
99965.59	1	< 0.1%
99958.74	1	< 0.1%
99944.01	1	< 0.1%
99938.14	1	< 0.1%
99932.81	1	< 0.1%
99925.51	1	< 0.1%
99920.71	1	< 0.1%

payment_frequency
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Quarterly	3432
Monthly	3324
Annually	3244

Length

Max length	9
Median length	8
Mean length	8.0108
Min length	7

Characters and Unicode

Total characters	80108
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Monthly
2nd row	Annually
3rd row	Quarterly
4th row	Annually
5th row	Monthly

Common Values

Value	Count	Frequency (%)
Quarterly	3432	34.3%
Monthly	3324	33.2%
Annually	3244	32.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
quarterly	3432	34.3%
monthly	3324	33.2%
annually	3244	32.4%

Most occurring characters

Value	Count	Frequency (%)
l	13244	16.5%
y	10000	12.5%
n	9812	12.2%
r	6864	8.6%
t	6756	8.4%
a	6676	8.3%
u	6676	8.3%
Q	3432	4.3%
e	3432	4.3%
M	3324	4.1%
Other values (3)	9892	12.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	80108	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	13244	16.5%
y	10000	12.5%
n	9812	12.2%
r	6864	8.6%
t	6756	8.4%
a	6676	8.3%
u	6676	8.3%
Q	3432	4.3%
e	3432	4.3%
M	3324	4.1%
Other values (3)	9892	12.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	80108	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	13244	16.5%
y	10000	12.5%
n	9812	12.2%
r	6864	8.6%
t	6756	8.4%
a	6676	8.3%
u	6676	8.3%
Q	3432	4.3%
e	3432	4.3%
M	3324	4.1%
Other values (3)	9892	12.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	80108	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	13244	16.5%
y	10000	12.5%
n	9812	12.2%
r	6864	8.6%
t	6756	8.4%
a	6676	8.3%
u	6676	8.3%
Q	3432	4.3%
e	3432	4.3%
M	3324	4.1%
Other values (3)	9892	12.3%

loan_eligible
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 KiB

True	5108
False	4892

Value	Count	Frequency (%)
True	5108	51.1%
False	4892	48.9%

loan_amount_allowed
Real number (ℝ)

High correlation

Distinct	9999
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	475327.13

Minimum	30894.54
Maximum	1181952.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	30894.54
5-th percentile	85841.391
Q1	248153.4
median	457602.98
Q3	672625.19
95-th percentile	950570.58
Maximum	1181952.2
Range	1151057.6
Interquartile range (IQR)	424471.79

Descriptive statistics

Standard deviation	267747.04
Coefficient of variation (CV)	0.56329005
Kurtosis	-0.77715878
Mean	475327.13
Median Absolute Deviation (MAD)	211792.03
Skewness	0.30950321
Sum	4.7532713 × 10⁹
Variance	7.1688479 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
687043.28	2	< 0.1%
447163.56	1	< 0.1%
251903.5	1	< 0.1%
513299.27	1	< 0.1%
199802.21	1	< 0.1%
709501.06	1	< 0.1%
73432.27	1	< 0.1%
361902.11	1	< 0.1%
732352.54	1	< 0.1%
864927.02	1	< 0.1%
Other values (9989)	9989	99.9%

Value	Count	Frequency (%)
30894.54	1	< 0.1%
32478.83	1	< 0.1%
32687.28	1	< 0.1%
32738.11	1	< 0.1%
33423.82	1	< 0.1%
34203.18	1	< 0.1%
34449.91	1	< 0.1%
34992.62	1	< 0.1%
35106.17	1	< 0.1%
35398.12	1	< 0.1%

Value	Count	Frequency (%)
1181952.17	1	< 0.1%
1180406.45	1	< 0.1%
1180065.66	1	< 0.1%
1173589.5	1	< 0.1%
1168924.57	1	< 0.1%
1166546.6	1	< 0.1%
1163269.88	1	< 0.1%
1161643.03	1	< 0.1%
1161325.84	1	< 0.1%
1161317.06	1	< 0.1%

underwriting_expenses
Real number (ℝ)

Distinct	9938
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5270.0628

Minimum	500.6
Maximum	9999.78
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	500.6
5-th percentile	971.745
Q1	2853.765
median	5264.165
Q3	7702.4975
95-th percentile	9542.81
Maximum	9999.78
Range	9499.18
Interquartile range (IQR)	4848.7325

Descriptive statistics

Standard deviation	2774.4241
Coefficient of variation (CV)	0.52644991
Kurtosis	-1.2283104
Mean	5270.0628
Median Absolute Deviation (MAD)	2422.77
Skewness	-0.0086640626
Sum	52700628
Variance	7697429.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8312.83	2	< 0.1%
1976.24	2	< 0.1%
2890.14	2	< 0.1%
2861.03	2	< 0.1%
8542.35	2	< 0.1%
9036.62	2	< 0.1%
4537.45	2	< 0.1%
1290.93	2	< 0.1%
6207.64	2	< 0.1%
5208.18	2	< 0.1%
Other values (9928)	9980	99.8%

Value	Count	Frequency (%)
500.6	1	< 0.1%
500.7	1	< 0.1%
501.09	1	< 0.1%
501.27	1	< 0.1%
502.19	1	< 0.1%
502.21	1	< 0.1%
502.29	1	< 0.1%
502.37	1	< 0.1%
503.83	1	< 0.1%
504.06	1	< 0.1%

Value	Count	Frequency (%)
9999.78	1	< 0.1%
9998.66	1	< 0.1%
9998.65	1	< 0.1%
9998.47	1	< 0.1%
9998.31	1	< 0.1%
9997.82	1	< 0.1%
9997.47	1	< 0.1%
9996.08	1	< 0.1%
9994.77	1	< 0.1%
9994.62	1	< 0.1%

sales_agent_code
Categorical

High correlation

Distinct	22
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

AGT-6578	1221
AGT-3567	1120
AGT-3488	1009
AGT-3150	819
AGT-2345	637
Other values (17)	5194

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	80000
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AGT-6578
2nd row	AGT-6578
3rd row	AGT-6578
4th row	AGT-6578
5th row	AGT-6578

Common Values

Value	Count	Frequency (%)
AGT-6578	1221	12.2%
AGT-3567	1120	11.2%
AGT-3488	1009	10.1%
AGT-3150	819	8.2%
AGT-2345	637	6.4%
AGT-5980	612	6.1%
AGT-3465	550	5.5%
AGT-4456	512	5.1%
AGT-5467	463	4.6%
AGT-7898	458	4.6%
Other values (12)	2599	26.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
agt-6578	1221	12.2%
agt-3567	1120	11.2%
agt-3488	1009	10.1%
agt-3150	819	8.2%
agt-2345	637	6.4%
agt-5980	612	6.1%
agt-3465	550	5.5%
agt-4456	512	5.1%
agt-5467	463	4.6%
agt-7898	458	4.6%
Other values (12)	2599	26.0%

Most occurring characters

Value	Count	Frequency (%)
A	10000	12.5%
G	10000	12.5%
T	10000	12.5%
-	10000	12.5%
5	7322	9.2%
4	5784	7.2%
8	5703	7.1%
3	4385	5.5%
6	3967	5.0%
9	3687	4.6%
Other values (4)	9152	11.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	10000	12.5%
G	10000	12.5%
T	10000	12.5%
-	10000	12.5%
5	7322	9.2%
4	5784	7.2%
8	5703	7.1%
3	4385	5.5%
6	3967	5.0%
9	3687	4.6%
Other values (4)	9152	11.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	10000	12.5%
G	10000	12.5%
T	10000	12.5%
-	10000	12.5%
5	7322	9.2%
4	5784	7.2%
8	5703	7.1%
3	4385	5.5%
6	3967	5.0%
9	3687	4.6%
Other values (4)	9152	11.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	10000	12.5%
G	10000	12.5%
T	10000	12.5%
-	10000	12.5%
5	7322	9.2%
4	5784	7.2%
8	5703	7.1%
3	4385	5.5%
6	3967	5.0%
9	3687	4.6%
Other values (4)	9152	11.4%

purchase_month
Categorical

High correlation

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

December	892
March	874
August	866
January	855
July	841
Other values (7)	5672

Length

Max length	9
Median length	7
Mean length	6.165
Min length	3

Characters and Unicode

Total characters	61650
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	January
2nd row	October
3rd row	April
4th row	November
5th row	February

Common Values

Value	Count	Frequency (%)
December	892	8.9%
March	874	8.7%
August	866	8.7%
January	855	8.6%
July	841	8.4%
November	840	8.4%
October	828	8.3%
May	827	8.3%
April	825	8.2%
September	817	8.2%
Other values (2)	1535	15.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
december	892	8.9%
march	874	8.7%
august	866	8.7%
january	855	8.6%
july	841	8.4%
november	840	8.4%
october	828	8.3%
may	827	8.3%
april	825	8.2%
september	817	8.2%
Other values (2)	1535	15.3%

Most occurring characters

Value	Count	Frequency (%)
e	9170	14.9%
r	7423	12.0%
u	4963	8.1%
a	4157	6.7%
b	4123	6.7%
y	3269	5.3%
c	2594	4.2%
m	2549	4.1%
t	2511	4.1%
J	2485	4.0%
Other values (16)	18406	29.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	61650	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	9170	14.9%
r	7423	12.0%
u	4963	8.1%
a	4157	6.7%
b	4123	6.7%
y	3269	5.3%
c	2594	4.2%
m	2549	4.1%
t	2511	4.1%
J	2485	4.0%
Other values (16)	18406	29.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	61650	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	9170	14.9%
r	7423	12.0%
u	4963	8.1%
a	4157	6.7%
b	4123	6.7%
y	3269	5.3%
c	2594	4.2%
m	2549	4.1%
t	2511	4.1%
J	2485	4.0%
Other values (16)	18406	29.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	61650	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	9170	14.9%
r	7423	12.0%
u	4963	8.1%
a	4157	6.7%
b	4123	6.7%
y	3269	5.3%
c	2594	4.2%
m	2549	4.1%
t	2511	4.1%
J	2485	4.0%
Other values (16)	18406	29.9%

purchase_quarter
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Q4	2560
Q3	2524
Q1	2475
Q2	2441

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	20000
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Q1
2nd row	Q4
3rd row	Q2
4th row	Q4
5th row	Q1

Common Values

Value	Count	Frequency (%)
Q4	2560	25.6%
Q3	2524	25.2%
Q1	2475	24.8%
Q2	2441	24.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
q4	2560	25.6%
q3	2524	25.2%
q1	2475	24.8%
q2	2441	24.4%

Most occurring characters

Value	Count	Frequency (%)
Q	10000	50.0%
4	2560	12.8%
3	2524	12.6%
1	2475	12.4%
2	2441	12.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	20000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
Q	10000	50.0%
4	2560	12.8%
3	2524	12.6%
1	2475	12.4%
2	2441	12.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	20000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
Q	10000	50.0%
4	2560	12.8%
3	2524	12.6%
1	2475	12.4%
2	2441	12.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	20000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
Q	10000	50.0%
4	2560	12.8%
3	2524	12.6%
1	2475	12.4%
2	2441	12.2%

purchase_year
Real number (ℝ)

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2020.0509

Minimum	2015
Maximum	2025
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	2015
5-th percentile	2016
Q1	2018
median	2020
Q3	2023
95-th percentile	2025
Maximum	2025
Range	10
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.9134787
Coefficient of variation (CV)	0.0014422798
Kurtosis	-1.1553952
Mean	2020.0509
Median Absolute Deviation (MAD)	2
Skewness	0.004066033
Sum	20200509
Variance	8.488358
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
2018	1092	10.9%
2022	1021	10.2%
2024	1019	10.2%
2016	994	9.9%
2019	990	9.9%
2021	983	9.8%
2020	977	9.8%
2023	974	9.7%
2017	953	9.5%
2025	548	5.5%

Value	Count	Frequency (%)
2015	449	4.5%
2016	994	9.9%
2017	953	9.5%
2018	1092	10.9%
2019	990	9.9%
2020	977	9.8%
2021	983	9.8%
2022	1021	10.2%
2023	974	9.7%
2024	1019	10.2%

Value	Count	Frequency (%)
2025	548	5.5%
2024	1019	10.2%
2023	974	9.7%
2022	1021	10.2%
2021	983	9.8%
2020	977	9.8%
2019	990	9.9%
2018	1092	10.9%
2017	953	9.5%
2016	994	9.9%

policy_anniversary_date
Date

Distinct	3428
Distinct (%)	34.3%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Minimum	2016-07-24 00:00:00
Maximum	2026-07-23 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

claim_id
Text

Distinct	9939
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	100000
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9879 ?
Unique (%)	98.8%

Sample

1st row	CLM-163983
2nd row	CLM-729665
3rd row	CLM-655001
4th row	CLM-101156
5th row	CLM-762598

Value	Count	Frequency (%)
clm-572815	3	< 0.1%
clm-843033	2	< 0.1%
clm-396245	2	< 0.1%
clm-258697	2	< 0.1%
clm-109753	2	< 0.1%
clm-687562	2	< 0.1%
clm-453110	2	< 0.1%
clm-749378	2	< 0.1%
clm-620062	2	< 0.1%
clm-833308	2	< 0.1%
Other values (9929)	9979	99.8%

Most occurring characters

Value	Count	Frequency (%)
C	10000	10.0%
L	10000	10.0%
M	10000	10.0%
-	10000	10.0%
5	6217	6.2%
7	6192	6.2%
6	6140	6.1%
3	6129	6.1%
1	6114	6.1%
2	6097	6.1%
Other values (4)	23111	23.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	10000	10.0%
L	10000	10.0%
M	10000	10.0%
-	10000	10.0%
5	6217	6.2%
7	6192	6.2%
6	6140	6.1%
3	6129	6.1%
1	6114	6.1%
2	6097	6.1%
Other values (4)	23111	23.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	10000	10.0%
L	10000	10.0%
M	10000	10.0%
-	10000	10.0%
5	6217	6.2%
7	6192	6.2%
6	6140	6.1%
3	6129	6.1%
1	6114	6.1%
2	6097	6.1%
Other values (4)	23111	23.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	10000	10.0%
L	10000	10.0%
M	10000	10.0%
-	10000	10.0%
5	6217	6.2%
7	6192	6.2%
6	6140	6.1%
3	6129	6.1%
1	6114	6.1%
2	6097	6.1%
Other values (4)	23111	23.1%

policy_type_code
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

TR-ENDD989	3383
TR-WHCD968	3347
TR-UNCD988	3270

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	100000
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TR-UNCD988
2nd row	TR-UNCD988
3rd row	TR-UNCD988
4th row	TR-UNCD988
5th row	TR-UNCD988

Common Values

Value	Count	Frequency (%)
TR-ENDD989	3383	33.8%
TR-WHCD968	3347	33.5%
TR-UNCD988	3270	32.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
tr-endd989	3383	33.8%
tr-whcd968	3347	33.5%
tr-uncd988	3270	32.7%

Most occurring characters

Value	Count	Frequency (%)
D	13383	13.4%
9	13383	13.4%
8	13270	13.3%
R	10000	10.0%
T	10000	10.0%
-	10000	10.0%
N	6653	6.7%
C	6617	6.6%
E	3383	3.4%
W	3347	3.3%
Other values (3)	9964	10.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
D	13383	13.4%
9	13383	13.4%
8	13270	13.3%
R	10000	10.0%
T	10000	10.0%
-	10000	10.0%
N	6653	6.7%
C	6617	6.6%
E	3383	3.4%
W	3347	3.3%
Other values (3)	9964	10.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
D	13383	13.4%
9	13383	13.4%
8	13270	13.3%
R	10000	10.0%
T	10000	10.0%
-	10000	10.0%
N	6653	6.7%
C	6617	6.6%
E	3383	3.4%
W	3347	3.3%
Other values (3)	9964	10.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
D	13383	13.4%
9	13383	13.4%
8	13270	13.3%
R	10000	10.0%
T	10000	10.0%
-	10000	10.0%
N	6653	6.7%
C	6617	6.6%
E	3383	3.4%
W	3347	3.3%
Other values (3)	9964	10.0%

policy_code
Categorical

High correlation

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

UGP-TRCD-9834	3205
JSU-TRCD-9813	2358
LGA-TRCD-9829	1818
STP-TRCD-9812	1236
ICP-TRCD-9832	972
Other values (3)	411

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	130000
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	UGP-TRCD-9834
2nd row	UGP-TRCD-9834
3rd row	UGP-TRCD-9834
4th row	UGP-TRCD-9834
5th row	UGP-TRCD-9834

Common Values

Value	Count	Frequency (%)
UGP-TRCD-9834	3205	32.0%
JSU-TRCD-9813	2358	23.6%
LGA-TRCD-9829	1818	18.2%
STP-TRCD-9812	1236	12.4%
ICP-TRCD-9832	972	9.7%
WLS-TRCD-9814	329	3.3%
RSE-TRCD-9856	65	0.7%
GWB-TRCD-9833	17	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ugp-trcd-9834	3205	32.0%
jsu-trcd-9813	2358	23.6%
lga-trcd-9829	1818	18.2%
stp-trcd-9812	1236	12.4%
icp-trcd-9832	972	9.7%
wls-trcd-9814	329	3.3%
rse-trcd-9856	65	0.7%
gwb-trcd-9833	17	0.2%

Most occurring characters

Value	Count	Frequency (%)
-	20000	15.4%
9	11818	9.1%
T	11236	8.6%
C	10972	8.4%
R	10065	7.7%
D	10000	7.7%
8	10000	7.7%
3	6569	5.1%
U	5563	4.3%
P	5413	4.2%
Other values (14)	28364	21.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	130000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	20000	15.4%
9	11818	9.1%
T	11236	8.6%
C	10972	8.4%
R	10065	7.7%
D	10000	7.7%
8	10000	7.7%
3	6569	5.1%
U	5563	4.3%
P	5413	4.2%
Other values (14)	28364	21.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	130000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	20000	15.4%
9	11818	9.1%
T	11236	8.6%
C	10972	8.4%
R	10065	7.7%
D	10000	7.7%
8	10000	7.7%
3	6569	5.1%
U	5563	4.3%
P	5413	4.2%
Other values (14)	28364	21.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	130000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	20000	15.4%
9	11818	9.1%
T	11236	8.6%
C	10972	8.4%
R	10065	7.7%
D	10000	7.7%
8	10000	7.7%
3	6569	5.1%
U	5563	4.3%
P	5413	4.2%
Other values (14)	28364	21.8%

policy_status
Categorical

Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Active	7332
Surrendered	2524
Lapsed	107
Claimed	37

Length

Max length	11
Median length	6
Mean length	7.2657
Min length	6

Characters and Unicode

Total characters	72657
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Active
2nd row	Active
3rd row	Active
4th row	Active
5th row	Active

Common Values

Value	Count	Frequency (%)
Active	7332	73.3%
Surrendered	2524	25.2%
Lapsed	107	1.1%
Claimed	37	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
active	7332	73.3%
surrendered	2524	25.2%
lapsed	107	1.1%
claimed	37	0.4%

Most occurring characters

Value	Count	Frequency (%)
e	15048	20.7%
r	7572	10.4%
i	7369	10.1%
A	7332	10.1%
c	7332	10.1%
t	7332	10.1%
v	7332	10.1%
d	5192	7.1%
u	2524	3.5%
S	2524	3.5%
Other values (8)	3100	4.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	72657	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	15048	20.7%
r	7572	10.4%
i	7369	10.1%
A	7332	10.1%
c	7332	10.1%
t	7332	10.1%
v	7332	10.1%
d	5192	7.1%
u	2524	3.5%
S	2524	3.5%
Other values (8)	3100	4.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	72657	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	15048	20.7%
r	7572	10.4%
i	7369	10.1%
A	7332	10.1%
c	7332	10.1%
t	7332	10.1%
v	7332	10.1%
d	5192	7.1%
u	2524	3.5%
S	2524	3.5%
Other values (8)	3100	4.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	72657	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	15048	20.7%
r	7572	10.4%
i	7369	10.1%
A	7332	10.1%
c	7332	10.1%
t	7332	10.1%
v	7332	10.1%
d	5192	7.1%
u	2524	3.5%
S	2524	3.5%
Other values (8)	3100	4.3%

state
Categorical

High correlation

Distinct	22
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Delhi	1221
Uttar Pradesh	1120
Sikkim	1009
Haryana	819
Madhya Pradesh	637
Other values (17)	5194

Length

Max length	16
Median length	13
Mean length	8.8023
Min length	3

Characters and Unicode

Total characters	88023
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Delhi
2nd row	Delhi
3rd row	Delhi
4th row	Delhi
5th row	Delhi

Common Values

Value	Count	Frequency (%)
Delhi	1221	12.2%
Uttar Pradesh	1120	11.2%
Sikkim	1009	10.1%
Haryana	819	8.2%
Madhya Pradesh	637	6.4%
Tamilnadu	612	6.1%
Rajasthan	550	5.5%
Bihar	512	5.1%
Chandigarh	463	4.6%
Uttarakhand	458	4.6%
Other values (12)	2599	26.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pradesh	2301	18.5%
delhi	1221	9.8%
uttar	1120	9.0%
sikkim	1009	8.1%
haryana	819	6.6%
madhya	637	5.1%
tamilnadu	612	4.9%
rajasthan	550	4.4%
bihar	512	4.1%
chandigarh	463	3.7%
Other values (14)	3209	25.8%

Most occurring characters

Value	Count	Frequency (%)
a	17899	20.3%
h	8562	9.7%
r	7840	8.9%
d	5240	6.0%
i	5236	5.9%
e	4402	5.0%
t	4319	4.9%
n	4169	4.7%
s	3949	4.5%
k	2992	3.4%
Other values (25)	23415	26.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	88023	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	17899	20.3%
h	8562	9.7%
r	7840	8.9%
d	5240	6.0%
i	5236	5.9%
e	4402	5.0%
t	4319	4.9%
n	4169	4.7%
s	3949	4.5%
k	2992	3.4%
Other values (25)	23415	26.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	88023	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	17899	20.3%
h	8562	9.7%
r	7840	8.9%
d	5240	6.0%
i	5236	5.9%
e	4402	5.0%
t	4319	4.9%
n	4169	4.7%
s	3949	4.5%
k	2992	3.4%
Other values (25)	23415	26.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	88023	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	17899	20.3%
h	8562	9.7%
r	7840	8.9%
d	5240	6.0%
i	5236	5.9%
e	4402	5.0%
t	4319	4.9%
n	4169	4.7%
s	3949	4.5%
k	2992	3.4%
Other values (25)	23415	26.6%

rm_id
Categorical

High correlation

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

RMN7A3X1	3799
RMC9F7L5	2018
RMS4B9K2	1661
RME2D5Q4	1509
RMW8C6P3	1013

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	80000
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RMN7A3X1
2nd row	RMN7A3X1
3rd row	RMN7A3X1
4th row	RMN7A3X1
5th row	RMN7A3X1

Common Values

Value	Count	Frequency (%)
RMN7A3X1	3799	38.0%
RMC9F7L5	2018	20.2%
RMS4B9K2	1661	16.6%
RME2D5Q4	1509	15.1%
RMW8C6P3	1013	10.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
rmn7a3x1	3799	38.0%
rmc9f7l5	2018	20.2%
rms4b9k2	1661	16.6%
rme2d5q4	1509	15.1%
rmw8c6p3	1013	10.1%

Most occurring characters

Value	Count	Frequency (%)
R	10000	12.5%
M	10000	12.5%
7	5817	7.3%
3	4812	6.0%
N	3799	4.7%
A	3799	4.7%
X	3799	4.7%
1	3799	4.7%
9	3679	4.6%
5	3527	4.4%
Other values (15)	26969	33.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
R	10000	12.5%
M	10000	12.5%
7	5817	7.3%
3	4812	6.0%
N	3799	4.7%
A	3799	4.7%
X	3799	4.7%
1	3799	4.7%
9	3679	4.6%
5	3527	4.4%
Other values (15)	26969	33.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
R	10000	12.5%
M	10000	12.5%
7	5817	7.3%
3	4812	6.0%
N	3799	4.7%
A	3799	4.7%
X	3799	4.7%
1	3799	4.7%
9	3679	4.6%
5	3527	4.4%
Other values (15)	26969	33.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
R	10000	12.5%
M	10000	12.5%
7	5817	7.3%
3	4812	6.0%
N	3799	4.7%
A	3799	4.7%
X	3799	4.7%
1	3799	4.7%
9	3679	4.6%
5	3527	4.4%
Other values (15)	26969	33.7%

zonal_manager_id
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

ZMN8K2L1	5817
ZMW3T7P8	2522
ZMS5Q4R2	1661

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	80000
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ZMN8K2L1
2nd row	ZMN8K2L1
3rd row	ZMN8K2L1
4th row	ZMN8K2L1
5th row	ZMN8K2L1

Common Values

Value	Count	Frequency (%)
ZMN8K2L1	5817	58.2%
ZMW3T7P8	2522	25.2%
ZMS5Q4R2	1661	16.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
zmn8k2l1	5817	58.2%
zmw3t7p8	2522	25.2%
zms5q4r2	1661	16.6%

Most occurring characters

Value	Count	Frequency (%)
Z	10000	12.5%
M	10000	12.5%
8	8339	10.4%
2	7478	9.3%
N	5817	7.3%
K	5817	7.3%
L	5817	7.3%
1	5817	7.3%
W	2522	3.2%
3	2522	3.2%
Other values (8)	15871	19.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
Z	10000	12.5%
M	10000	12.5%
8	8339	10.4%
2	7478	9.3%
N	5817	7.3%
K	5817	7.3%
L	5817	7.3%
1	5817	7.3%
W	2522	3.2%
3	2522	3.2%
Other values (8)	15871	19.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
Z	10000	12.5%
M	10000	12.5%
8	8339	10.4%
2	7478	9.3%
N	5817	7.3%
K	5817	7.3%
L	5817	7.3%
1	5817	7.3%
W	2522	3.2%
3	2522	3.2%
Other values (8)	15871	19.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
Z	10000	12.5%
M	10000	12.5%
8	8339	10.4%
2	7478	9.3%
N	5817	7.3%
K	5817	7.3%
L	5817	7.3%
1	5817	7.3%
W	2522	3.2%
3	2522	3.2%
Other values (8)	15871	19.8%

payment_frequency_days
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

90	3432
30	3324
365	3244

Length

Max length	3
Median length	2
Mean length	2.3244
Min length	2

Characters and Unicode

Total characters	23244
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	30
2nd row	365
3rd row	90
4th row	365
5th row	30

Common Values

Value	Count	Frequency (%)
90	3432	34.3%
30	3324	33.2%
365	3244	32.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
90	3432	34.3%
30	3324	33.2%
365	3244	32.4%

Most occurring characters

Value	Count	Frequency (%)
0	6756	29.1%
3	6568	28.3%
9	3432	14.8%
6	3244	14.0%
5	3244	14.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	23244	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	6756	29.1%
3	6568	28.3%
9	3432	14.8%
6	3244	14.0%
5	3244	14.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	23244	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	6756	29.1%
3	6568	28.3%
9	3432	14.8%
6	3244	14.0%
5	3244	14.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	23244	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	6756	29.1%
3	6568	28.3%
9	3432	14.8%
6	3244	14.0%
5	3244	14.0%

Interactions

Correlations

	loan_amount_allowed	loan_eligible	payment_frequency	payment_frequency_days	policy_code	policy_status	policy_type_code	premium_amount	purchase_month	purchase_quarter	purchase_year	rm_id	sales_agent_code	state	sum_assured_inr/coverage_amount	tenure_(years)	underwriting_expenses	zonal_manager_id
loan_amount_allowed	1.000	0.000	0.022	0.022	0.006	0.008	0.013	-0.006	0.010	0.011	0.002	0.000	0.000	0.000	0.937	-0.007	-0.010	0.000
loan_eligible	0.000	1.000	0.000	0.000	0.021	0.029	0.000	0.000	0.000	0.005	0.000	0.000	0.000	0.000	0.000	0.000	0.008	0.000
payment_frequency	0.022	0.000	1.000	1.000	0.013	0.007	0.010	0.000	0.022	0.020	0.000	0.009	0.026	0.026	0.019	0.000	0.000	0.004
payment_frequency_days	0.022	0.000	1.000	1.000	0.013	0.007	0.010	0.000	0.022	0.020	0.000	0.009	0.026	0.026	0.019	0.000	0.000	0.004
policy_code	0.006	0.021	0.013	0.013	1.000	0.123	1.000	0.010	0.000	0.005	0.000	0.163	0.232	0.232	0.000	1.000	0.024	0.217
policy_status	0.008	0.029	0.007	0.007	0.123	1.000	0.000	0.005	0.000	0.000	0.000	0.138	0.298	0.298	0.010	0.086	0.007	0.072
policy_type_code	0.013	0.000	0.010	0.010	1.000	0.000	1.000	0.007	0.000	0.011	0.005	0.004	0.036	0.036	0.000	0.871	0.000	0.004
premium_amount	-0.006	0.000	0.000	0.000	0.010	0.005	0.007	1.000	0.009	0.003	-0.015	0.015	0.006	0.006	-0.007	-0.009	0.008	0.023
purchase_month	0.010	0.000	0.022	0.022	0.000	0.000	0.000	0.009	1.000	1.000	0.082	0.009	0.000	0.000	0.017	0.006	0.015	0.013
purchase_quarter	0.011	0.005	0.020	0.020	0.005	0.000	0.011	0.003	1.000	1.000	0.133	0.012	0.000	0.000	0.022	0.007	0.008	0.006
purchase_year	0.002	0.000	0.000	0.000	0.000	0.000	0.005	-0.015	0.082	0.133	1.000	0.009	0.005	0.005	0.010	-0.009	-0.016	0.000
rm_id	0.000	0.000	0.009	0.009	0.163	0.138	0.004	0.015	0.009	0.012	0.009	1.000	0.999	0.999	0.000	0.108	0.000	1.000
sales_agent_code	0.000	0.000	0.026	0.026	0.232	0.298	0.036	0.006	0.000	0.000	0.005	0.999	1.000	1.000	0.000	0.183	0.005	0.999
state	0.000	0.000	0.026	0.026	0.232	0.298	0.036	0.006	0.000	0.000	0.005	0.999	1.000	1.000	0.000	0.183	0.005	0.999
sum_assured_inr/coverage_amount	0.937	0.000	0.019	0.019	0.000	0.010	0.000	-0.007	0.017	0.022	0.010	0.000	0.000	0.000	1.000	-0.007	-0.009	0.000
tenure_(years)	-0.007	0.000	0.000	0.000	1.000	0.086	0.871	-0.009	0.006	0.007	-0.009	0.108	0.183	0.183	-0.007	1.000	0.009	0.145
underwriting_expenses	-0.010	0.008	0.000	0.000	0.024	0.007	0.000	0.008	0.015	0.008	-0.016	0.000	0.005	0.005	-0.009	0.009	1.000	0.005
zonal_manager_id	0.000	0.000	0.004	0.004	0.217	0.072	0.004	0.023	0.013	0.006	0.000	1.000	0.999	0.999	0.000	0.145	0.005	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	policy_number	start_date	last_paid_date	tenure_(years)	date_of_purchase	customer_id	sum_assured_inr/coverage_amount	premium_amount	payment_frequency	loan_eligible	loan_amount_allowed	underwriting_expenses	sales_agent_code	purchase_month	purchase_quarter	purchase_year	policy_anniversary_date	claim_id	policy_type_code	policy_code	policy_status	state	rm_id	zonal_manager_id	payment_frequency_days
0	TRS-POL-287638	28-01-2017	28-Jan-25	20	28-Jan-17	CUST-912138	1837929.13	18946.30	Monthly	No	709501.06	9003.34	AGT-6578	January	Q1	2017	28-Jan-18	CLM-163983	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	30
1	TRS-POL-983850	27-10-2017	27-Oct-25	20	27-Oct-17	CUST-676760	143416.16	64648.36	Annually	Yes	73432.27	2808.23	AGT-6578	October	Q4	2017	27-Oct-18	CLM-729665	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	365
2	TRS-POL-892387	18-04-2022	18-Apr-25	20	18-Apr-22	CUST-189349	619301.17	42085.47	Quarterly	Yes	361902.11	3335.88	AGT-6578	April	Q2	2022	18-Apr-23	CLM-655001	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	90
3	TRS-POL-204292	20-11-2019	20-Nov-25	20	20-Nov-19	CUST-567423	1852545.62	97105.30	Annually	Yes	732352.54	4715.71	AGT-6578	November	Q4	2019	20-Nov-20	CLM-101156	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	365
4	TRS-POL-621019	13-02-2023	13-Feb-25	20	13-Feb-23	CUST-292627	1882565.42	89233.91	Monthly	No	864927.02	5166.29	AGT-6578	February	Q1	2023	13-Feb-24	CLM-762598	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	30
5	TRS-POL-603900	19-04-2019	19-Apr-25	20	19-Apr-19	CUST-802812	1330929.44	24594.09	Quarterly	Yes	503997.37	7587.61	AGT-6578	April	Q2	2019	19-Apr-20	CLM-739868	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	90
6	TRS-POL-371850	26-08-2016	26-Aug-25	20	26-Aug-16	CUST-285115	1852113.26	33450.86	Annually	No	824389.81	7388.20	AGT-6578	August	Q3	2016	26-Aug-17	CLM-590747	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	365
7	TRS-POL-336174	12-08-2019	12-Aug-25	20	12-Aug-19	CUST-541584	714993.62	76687.52	Quarterly	Yes	261604.73	4288.23	AGT-6578	August	Q3	2019	12-Aug-20	CLM-597333	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	90
8	TRS-POL-745853	14-11-2016	14-Nov-25	20	14-Nov-16	CUST-192788	270848.26	18826.75	Quarterly	Yes	141297.41	6725.00	AGT-6578	November	Q4	2016	14-Nov-17	CLM-765047	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	90
9	TRS-POL-192191	06-01-2023	06-Jan-25	20	06-Jan-23	CUST-226778	1500910.12	71206.95	Annually	Yes	886258.09	1346.17	AGT-6578	January	Q1	2023	06-Jan-24	CLM-790890	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	365

	policy_number	start_date	last_paid_date	tenure_(years)	date_of_purchase	customer_id	sum_assured_inr/coverage_amount	premium_amount	payment_frequency	loan_eligible	loan_amount_allowed	underwriting_expenses	sales_agent_code	purchase_month	purchase_quarter	purchase_year	policy_anniversary_date	claim_id	policy_type_code	policy_code	policy_status	state	rm_id	zonal_manager_id	payment_frequency_days
9990	TRS-POL-820102	12-09-2023	12-Sep-24	20	12-Sep-23	CUST-541253	1967825.03	87386.80	Annually	Yes	1118956.65	3921.03	AGT-7898	September	Q3	2023	12-Sep-24	CLM-912030	TR-UNCD988	UGP-TRCD-9834	Surrendered	Uttarakhand	RMN7A3X1	ZMN8K2L1	365
9991	TRS-POL-525507	19-08-2017	19-Aug-20	20	19-Aug-17	CUST-988183	1446839.21	60380.44	Monthly	Yes	456004.58	7381.60	AGT-7898	August	Q3	2017	19-Aug-18	CLM-591517	TR-UNCD988	UGP-TRCD-9834	Surrendered	Uttarakhand	RMN7A3X1	ZMN8K2L1	30
9992	TRS-POL-329212	20-11-2021	20-Nov-23	20	20-Nov-21	CUST-461264	859050.29	46748.59	Monthly	Yes	319082.84	3629.81	AGT-7898	November	Q4	2021	20-Nov-22	CLM-862321	TR-UNCD988	UGP-TRCD-9834	Surrendered	Uttarakhand	RMN7A3X1	ZMN8K2L1	30
9993	TRS-POL-146807	01-05-2018	01-May-21	20	01-May-18	CUST-970886	673382.05	11430.65	Quarterly	Yes	233625.16	9297.07	AGT-7898	May	Q2	2018	01-May-19	CLM-695622	TR-UNCD988	UGP-TRCD-9834	Surrendered	Uttarakhand	RMN7A3X1	ZMN8K2L1	90
9994	TRS-POL-432041	25-08-2023	25-Aug-24	20	25-Aug-23	CUST-563060	387560.56	42480.40	Annually	Yes	223900.87	5700.98	AGT-7898	August	Q3	2023	25-Aug-24	CLM-290388	TR-UNCD988	UGP-TRCD-9834	Surrendered	Uttarakhand	RMN7A3X1	ZMN8K2L1	365
9995	TRS-POL-465487	07-12-2017	07-Dec-20	20	07-Dec-17	CUST-439248	302465.10	21576.84	Monthly	Yes	154790.07	6890.88	AGT-7898	December	Q4	2017	07-Dec-18	CLM-934830	TR-UNCD988	UGP-TRCD-9834	Surrendered	Uttarakhand	RMN7A3X1	ZMN8K2L1	30
9996	TRS-POL-956994	19-04-2020	19-Apr-22	20	19-Apr-20	CUST-239999	204448.30	59548.60	Monthly	No	112221.94	8675.45	AGT-7898	April	Q2	2020	19-Apr-21	CLM-507329	TR-UNCD988	UGP-TRCD-9834	Surrendered	Uttarakhand	RMN7A3X1	ZMN8K2L1	30
9997	TRS-POL-461662	15-07-2019	15-Jul-21	20	15-Jul-19	CUST-400763	658445.39	67869.60	Annually	Yes	322829.68	8633.53	AGT-7898	July	Q3	2019	15-Jul-20	CLM-465856	TR-UNCD988	UGP-TRCD-9834	Surrendered	Uttarakhand	RMN7A3X1	ZMN8K2L1	365
9998	TRS-POL-401998	09-03-2017	09-Mar-20	20	09-Mar-17	CUST-684678	1748404.03	62139.29	Quarterly	Yes	826357.54	7101.07	AGT-7898	March	Q1	2017	09-Mar-18	CLM-533930	TR-UNCD988	UGP-TRCD-9834	Surrendered	Uttarakhand	RMN7A3X1	ZMN8K2L1	90
9999	TRS-POL-894552	26-01-2020	26-Jan-22	20	26-Jan-20	CUST-510641	472185.45	96062.59	Monthly	No	199802.21	3369.91	AGT-7898	January	Q1	2020	26-Jan-21	CLM-113772	TR-UNCD988	UGP-TRCD-9834	Surrendered	Uttarakhand	RMN7A3X1	ZMN8K2L1	30

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks